Overview

Dataset statistics

Number of variables16
Number of observations57793
Missing cells0
Missing cells (%)0.0%
Duplicate rows37
Duplicate rows (%)0.1%
Total size in memory7.1 MiB
Average record size in memory128.0 B

Variable types

NUM12
CAT4

Reproduction

Analysis started2020-08-23 14:01:22.448072
Analysis finished2020-08-23 14:04:56.782598
Duration3 minutes and 34.33 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Dataset has 37 (0.1%) duplicate rows Duplicates
country_full has a high cardinality: 216 distinct values High cardinality
country_abrv has a high cardinality: 216 distinct values High cardinality
rank_date has a high cardinality: 286 distinct values High cardinality
cur_year_avg is highly correlated with total_points and 1 other fieldsHigh correlation
total_points is highly correlated with cur_year_avg and 7 other fieldsHigh correlation
cur_year_avg_weighted is highly correlated with total_points and 1 other fieldsHigh correlation
last_year_avg is highly correlated with total_points and 1 other fieldsHigh correlation
last_year_avg_weighted is highly correlated with total_points and 1 other fieldsHigh correlation
two_year_ago_avg is highly correlated with total_points and 1 other fieldsHigh correlation
two_year_ago_weighted is highly correlated with total_points and 1 other fieldsHigh correlation
three_year_ago_avg is highly correlated with total_points and 1 other fieldsHigh correlation
three_year_ago_weighted is highly correlated with total_points and 1 other fieldsHigh correlation
rank_date is uniformly distributed Uniform
total_points has 40712 (70.4%) zeros Zeros
previous_points has 1380 (2.4%) zeros Zeros
rank_change has 15453 (26.7%) zeros Zeros
cur_year_avg has 42516 (73.6%) zeros Zeros
cur_year_avg_weighted has 42516 (73.6%) zeros Zeros
last_year_avg has 42634 (73.8%) zeros Zeros
last_year_avg_weighted has 42634 (73.8%) zeros Zeros
two_year_ago_avg has 42881 (74.2%) zeros Zeros
two_year_ago_weighted has 42881 (74.2%) zeros Zeros
three_year_ago_avg has 42930 (74.3%) zeros Zeros
three_year_ago_weighted has 42930 (74.3%) zeros Zeros

Variables

rank
Real number (ℝ≥0)

Distinct count209
Unique (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean101.62808644645546
Minimum1
Maximum209
Zeros0
Zeros (%)0.0%
Memory size451.5 KiB

Quantile statistics

Minimum1
5-th percentile11
Q151
median101
Q3152
95-th percentile194
Maximum209
Range208
Interquartile range (IQR)101

Descriptive statistics

Standard deviation58.61842434
Coefficient of variation (CV)0.5767935459
Kurtosis-1.179510343
Mean101.6280864
Median Absolute Deviation (MAD)50
Skewness0.01822593373
Sum5873392
Variance3436.119672
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1473030.5%
 
1203010.5%
 
1123010.5%
 
1993000.5%
 
1532990.5%
 
1292990.5%
 
1332980.5%
 
1512980.5%
 
1562980.5%
 
592970.5%
 
Other values (199)5479994.8%
 
ValueCountFrequency (%) 
12860.5%
 
22870.5%
 
32850.5%
 
42900.5%
 
52900.5%
 
ValueCountFrequency (%) 
2099< 0.1%
 
20819< 0.1%
 
207890.2%
 
2061380.2%
 
2051600.3%
 

country_full
Categorical

HIGH CARDINALITY

Distinct count216
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size451.5 KiB
Sudan
 
325
Costa Rica
 
286
Iceland
 
286
Singapore
 
286
Belarus
 
286
Other values (211)
56324
ValueCountFrequency (%) 
Sudan3250.6%
 
Costa Rica2860.5%
 
Iceland2860.5%
 
Singapore2860.5%
 
Belarus2860.5%
 
Malawi2860.5%
 
Australia2860.5%
 
Finland2860.5%
 
Malta2860.5%
 
Uruguay2860.5%
 
Other values (206)5489495.0%
 

Length

Max length29
Median length7
Mean length8.72109079
Min length3

country_abrv
Categorical

HIGH CARDINALITY

Distinct count216
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size451.5 KiB
SDN
 
325
TUR
 
286
YEM
 
286
SIN
 
286
LBY
 
286
Other values (211)
56324
ValueCountFrequency (%) 
SDN3250.6%
 
TUR2860.5%
 
YEM2860.5%
 
SIN2860.5%
 
LBY2860.5%
 
ITA2860.5%
 
PUR2860.5%
 
BEN2860.5%
 
ISL2860.5%
 
PRK2860.5%
 
Other values (206)5489495.0%
 

Length

Max length3
Median length3
Mean length3
Min length3

total_points
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count11114
Unique (%)19.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122.06863685913518
Minimum0.0
Maximum1775.03
Zeros40712
Zeros (%)70.4%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q392.79
95-th percentile730.084
Maximum1775.03
Range1775.03
Interquartile range (IQR)92.79

Descriptive statistics

Standard deviation260.4268632
Coefficient of variation (CV)2.133446149
Kurtosis6.893278156
Mean122.0686369
Median Absolute Deviation (MAD)0
Skewness2.587571993
Sum7054712.73
Variance67822.15108
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04071270.4%
 
63.75480.1%
 
38.25390.1%
 
66330.1%
 
127.5310.1%
 
33310.1%
 
4.326< 0.1%
 
25.824< 0.1%
 
29.7523< 0.1%
 
51.622< 0.1%
 
Other values (11104)1680429.1%
 
ValueCountFrequency (%) 
04071270.4%
 
1.473< 0.1%
 
1.712< 0.1%
 
1.769< 0.1%
 
2.22< 0.1%
 
ValueCountFrequency (%) 
1775.031< 0.1%
 
1770.061< 0.1%
 
1765.051< 0.1%
 
1735.721< 0.1%
 
1728.781< 0.1%
 

previous_points
Real number (ℝ≥0)

ZEROS

Distinct count1557
Unique (%)2.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean332.30292595989135
Minimum0
Maximum1920
Zeros1380
Zeros (%)2.4%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile6
Q156
median272
Q3525
95-th percentile882
Maximum1920
Range1920
Interquartile range (IQR)469

Descriptive statistics

Standard deviation302.8729476
Coefficient of variation (CV)0.9114362948
Kurtosis1.309953598
Mean332.302926
Median Absolute Deviation (MAD)225
Skewness1.09826437
Sum19204783
Variance91732.02239
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
013802.4%
 
63510.6%
 
113400.6%
 
83300.6%
 
173190.6%
 
43180.6%
 
133180.6%
 
33170.5%
 
73050.5%
 
333010.5%
 
Other values (1547)5351492.6%
 
ValueCountFrequency (%) 
013802.4%
 
12510.4%
 
22510.4%
 
33170.5%
 
43180.6%
 
ValueCountFrequency (%) 
19201< 0.1%
 
18873< 0.1%
 
18832< 0.1%
 
18811< 0.1%
 
18801< 0.1%
 

rank_change
Real number (ℝ)

ZEROS

Distinct count121
Unique (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.009897392417766857
Minimum-72
Maximum92
Zeros15453
Zeros (%)26.7%
Memory size451.5 KiB

Quantile statistics

Minimum-72
5-th percentile-7
Q1-2
median0
Q31
95-th percentile8
Maximum92
Range164
Interquartile range (IQR)3

Descriptive statistics

Standard deviation5.804308534
Coefficient of variation (CV)-586.4482572
Kurtosis19.65192743
Mean-0.009897392418
Median Absolute Deviation (MAD)1
Skewness1.237196204
Sum-572
Variance33.68999755
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
01545326.7%
 
-1803613.9%
 
1589410.2%
 
-249218.5%
 
232285.6%
 
-331225.4%
 
320753.6%
 
-419483.4%
 
414812.6%
 
-512652.2%
 
Other values (111)1037017.9%
 
ValueCountFrequency (%) 
-721< 0.1%
 
-621< 0.1%
 
-532< 0.1%
 
-521< 0.1%
 
-502< 0.1%
 
ValueCountFrequency (%) 
921< 0.1%
 
821< 0.1%
 
771< 0.1%
 
731< 0.1%
 
721< 0.1%
 

cur_year_avg
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7419
Unique (%)12.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61.798602252867994
Minimum0.0
Maximum1158.66
Zeros42516
Zeros (%)73.6%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q332.25
95-th percentile380.126
Maximum1158.66
Range1158.66
Interquartile range (IQR)32.25

Descriptive statistics

Standard deviation138.0148829
Coefficient of variation (CV)2.233301043
Kurtosis8.44786737
Mean61.79860225
Median Absolute Deviation (MAD)0
Skewness2.78375619
Sum3571526.62
Variance19048.10789
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04251673.6%
 
21.25850.1%
 
63.75780.1%
 
42.5560.1%
 
66550.1%
 
85540.1%
 
34510.1%
 
64.5500.1%
 
127.5500.1%
 
25.5480.1%
 
Other values (7409)1475025.5%
 
ValueCountFrequency (%) 
04251673.6%
 
3.865< 0.1%
 
4.252< 0.1%
 
4.721< 0.1%
 
6.077< 0.1%
 
ValueCountFrequency (%) 
1158.661< 0.1%
 
1153.121< 0.1%
 
1126.041< 0.1%
 
1112.982< 0.1%
 
1090.544< 0.1%
 

cur_year_avg_weighted
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7419
Unique (%)12.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61.798602252867994
Minimum0.0
Maximum1158.66
Zeros42516
Zeros (%)73.6%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q332.25
95-th percentile380.126
Maximum1158.66
Range1158.66
Interquartile range (IQR)32.25

Descriptive statistics

Standard deviation138.0148829
Coefficient of variation (CV)2.233301043
Kurtosis8.44786737
Mean61.79860225
Median Absolute Deviation (MAD)0
Skewness2.78375619
Sum3571526.62
Variance19048.10789
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04251673.6%
 
21.25850.1%
 
63.75780.1%
 
42.5560.1%
 
66550.1%
 
85540.1%
 
34510.1%
 
64.5500.1%
 
127.5500.1%
 
25.5480.1%
 
Other values (7409)1475025.5%
 
ValueCountFrequency (%) 
04251673.6%
 
3.865< 0.1%
 
4.252< 0.1%
 
4.721< 0.1%
 
6.077< 0.1%
 
ValueCountFrequency (%) 
1158.661< 0.1%
 
1153.121< 0.1%
 
1126.041< 0.1%
 
1112.982< 0.1%
 
1090.544< 0.1%
 

last_year_avg
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7473
Unique (%)12.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61.00460228747426
Minimum0.0
Maximum1169.57
Zeros42634
Zeros (%)73.8%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q326.66
95-th percentile372.624
Maximum1169.57
Range1169.57
Interquartile range (IQR)26.66

Descriptive statistics

Standard deviation137.6882037
Coefficient of variation (CV)2.257013382
Kurtosis9.397350184
Mean61.00460229
Median Absolute Deviation (MAD)0
Skewness2.881456975
Sum3525638.98
Variance18958.04145
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04263473.8%
 
66790.1%
 
21.25690.1%
 
63.75620.1%
 
26.4570.1%
 
64.5530.1%
 
25.8520.1%
 
127.5500.1%
 
42.5460.1%
 
85450.1%
 
Other values (7463)1464625.3%
 
ValueCountFrequency (%) 
04263473.8%
 
3.865< 0.1%
 
4.252< 0.1%
 
5.831< 0.1%
 
6.072< 0.1%
 
ValueCountFrequency (%) 
1169.571< 0.1%
 
1159.711< 0.1%
 
1158.661< 0.1%
 
1153.121< 0.1%
 
1112.981< 0.1%
 

last_year_avg_weighted
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7001
Unique (%)12.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30.502377450556295
Minimum0.0
Maximum584.79
Zeros42634
Zeros (%)73.8%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q313.33
95-th percentile186.312
Maximum584.79
Range584.79
Interquartile range (IQR)13.33

Descriptive statistics

Standard deviation68.84414345
Coefficient of variation (CV)2.257009099
Kurtosis9.397297397
Mean30.50237745
Median Absolute Deviation (MAD)0
Skewness2.881449511
Sum1762823.9
Variance4739.516088
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04263473.8%
 
33790.1%
 
10.63690.1%
 
31.88620.1%
 
13.2570.1%
 
32.25530.1%
 
12.9520.1%
 
63.75500.1%
 
21.25460.1%
 
17450.1%
 
Other values (6991)1464625.3%
 
ValueCountFrequency (%) 
04263473.8%
 
1.935< 0.1%
 
2.132< 0.1%
 
2.911< 0.1%
 
3.042< 0.1%
 
ValueCountFrequency (%) 
584.791< 0.1%
 
579.851< 0.1%
 
579.331< 0.1%
 
576.561< 0.1%
 
556.491< 0.1%
 

two_year_ago_avg
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7575
Unique (%)13.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean59.77746214939526
Minimum0.0
Maximum1159.71
Zeros42881
Zeros (%)74.2%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q321.5
95-th percentile377.23
Maximum1159.71
Range1159.71
Interquartile range (IQR)21.5

Descriptive statistics

Standard deviation136.2960787
Coefficient of variation (CV)2.280057966
Kurtosis9.346097184
Mean59.77746215
Median Absolute Deviation (MAD)0
Skewness2.879949855
Sum3454718.87
Variance18576.62108
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04288174.2%
 
66780.1%
 
21.25760.1%
 
25.5700.1%
 
8.5680.1%
 
34670.1%
 
26.4550.1%
 
64.5540.1%
 
25.8510.1%
 
42.5470.1%
 
Other values (7565)1434624.8%
 
ValueCountFrequency (%) 
04288174.2%
 
6.144< 0.1%
 
7.083< 0.1%
 
7.173< 0.1%
 
7.332< 0.1%
 
ValueCountFrequency (%) 
1159.711< 0.1%
 
1158.661< 0.1%
 
1153.121< 0.1%
 
1126.041< 0.1%
 
1112.982< 0.1%
 

two_year_ago_weighted
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count6513
Unique (%)11.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.933277386534705
Minimum0.0
Maximum347.91
Zeros42881
Zeros (%)74.2%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q36.45
95-th percentile113.17
Maximum347.91
Range347.91
Interquartile range (IQR)6.45

Descriptive statistics

Standard deviation40.8888489
Coefficient of variation (CV)2.28005445
Kurtosis9.346066533
Mean17.93327739
Median Absolute Deviation (MAD)0
Skewness2.879945895
Sum1036417.9
Variance1671.897964
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04288174.2%
 
19.8780.1%
 
6.38760.1%
 
7.65700.1%
 
2.55680.1%
 
10.2670.1%
 
7.92550.1%
 
19.35540.1%
 
7.74510.1%
 
12.75470.1%
 
Other values (6503)1434624.8%
 
ValueCountFrequency (%) 
04288174.2%
 
1.844< 0.1%
 
2.123< 0.1%
 
2.153< 0.1%
 
2.22< 0.1%
 
ValueCountFrequency (%) 
347.911< 0.1%
 
347.61< 0.1%
 
345.941< 0.1%
 
337.811< 0.1%
 
333.892< 0.1%
 

three_year_ago_avg
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7628
Unique (%)13.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean59.173916391258466
Minimum0.0
Maximum1200.77
Zeros42930
Zeros (%)74.3%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q321.25
95-th percentile372.844
Maximum1200.77
Range1200.77
Interquartile range (IQR)21.25

Descriptive statistics

Standard deviation135.5333429
Coefficient of variation (CV)2.290423741
Kurtosis9.696436119
Mean59.17391639
Median Absolute Deviation (MAD)0
Skewness2.909801534
Sum3419838.15
Variance18369.28705
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04293074.3%
 
8.5720.1%
 
25.5720.1%
 
66710.1%
 
34690.1%
 
21.25630.1%
 
42.5620.1%
 
26.4560.1%
 
25.8540.1%
 
64.5520.1%
 
Other values (7618)1429224.7%
 
ValueCountFrequency (%) 
04293074.3%
 
5.831< 0.1%
 
6.144< 0.1%
 
6.311< 0.1%
 
7.083< 0.1%
 
ValueCountFrequency (%) 
1200.771< 0.1%
 
1158.661< 0.1%
 
1136.571< 0.1%
 
1126.041< 0.1%
 
1119.111< 0.1%
 

three_year_ago_weighted
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count5849
Unique (%)10.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.834811136296786
Minimum0.0
Maximum240.15
Zeros42930
Zeros (%)74.3%
Memory size451.5 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q34.25
95-th percentile74.568
Maximum240.15
Range240.15
Interquartile range (IQR)4.25

Descriptive statistics

Standard deviation27.10667505
Coefficient of variation (CV)2.290418896
Kurtosis9.696365035
Mean11.83481114
Median Absolute Deviation (MAD)0
Skewness2.909793556
Sum683969.24
Variance734.7718325
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
04293074.3%
 
1.7720.1%
 
5.1720.1%
 
13.2710.1%
 
6.8690.1%
 
4.25630.1%
 
8.5620.1%
 
5.28560.1%
 
5.16540.1%
 
12.9520.1%
 
Other values (5839)1429224.7%
 
ValueCountFrequency (%) 
04293074.3%
 
1.171< 0.1%
 
1.234< 0.1%
 
1.261< 0.1%
 
1.423< 0.1%
 
ValueCountFrequency (%) 
240.151< 0.1%
 
231.731< 0.1%
 
227.311< 0.1%
 
225.211< 0.1%
 
223.821< 0.1%
 

confederation
Categorical

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size451.5 KiB
UEFA
14933
CAF
14876
AFC
12617
CONCACAF
9664
CONMEBOL
 
2860
ValueCountFrequency (%) 
UEFA1493325.8%
 
CAF1487625.7%
 
AFC1261721.8%
 
CONCACAF966416.7%
 
CONMEBOL28604.9%
 
OFC28434.9%
 

Length

Max length8
Median length3
Mean length4.34190992
Min length3

rank_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count286
Unique (%)0.5%
Missing0
Missing (%)0.0%
Memory size451.5 KiB
2018-06-07
 
211
2016-11-24
 
211
2016-10-20
 
211
2017-12-21
 
211
2017-03-09
 
211
Other values (281)
56738
ValueCountFrequency (%) 
2018-06-072110.4%
 
2016-11-242110.4%
 
2016-10-202110.4%
 
2017-12-212110.4%
 
2017-03-092110.4%
 
2017-10-162110.4%
 
2017-02-092110.4%
 
2017-06-012110.4%
 
2018-02-152110.4%
 
2016-12-222110.4%
 
Other values (276)5568396.3%
 

Length

Max length10
Median length10
Mean length10
Min length10

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

rankcountry_fullcountry_abrvtotal_pointsprevious_pointsrank_changecur_year_avgcur_year_avg_weightedlast_year_avglast_year_avg_weightedtwo_year_ago_avgtwo_year_ago_weightedthree_year_ago_avgthree_year_ago_weightedconfederationrank_date
01GermanyGER0.05700.00.00.00.00.00.00.00.0UEFA1993-08-08
12ItalyITA0.05700.00.00.00.00.00.00.00.0UEFA1993-08-08
23SwitzerlandSUI0.05090.00.00.00.00.00.00.00.0UEFA1993-08-08
34SwedenSWE0.05500.00.00.00.00.00.00.00.0UEFA1993-08-08
45ArgentinaARG0.05150.00.00.00.00.00.00.00.0CONMEBOL1993-08-08
56Republic of IrelandIRL0.05400.00.00.00.00.00.00.00.0UEFA1993-08-08
67RussiaRUS0.05210.00.00.00.00.00.00.00.0UEFA1993-08-08
78BrazilBRA0.055-50.00.00.00.00.00.00.00.0CONMEBOL1993-08-08
89NorwayNOR0.04950.00.00.00.00.00.00.00.0UEFA1993-08-08
910DenmarkDEN0.051-10.00.00.00.00.00.00.00.0UEFA1993-08-08

Last rows

rankcountry_fullcountry_abrvtotal_pointsprevious_pointsrank_changecur_year_avgcur_year_avg_weightedlast_year_avglast_year_avg_weightedtwo_year_ago_avgtwo_year_ago_weightedthree_year_ago_avgthree_year_ago_weightedconfederationrank_date
57783202Cayman IslandsCAY8.50920.00.00.00.00.00.042.508.50CONCACAF2018-06-07
57784203San MarinoSMR7.92820.00.00.00.00.00.039.607.92UEFA2018-06-07
57785204British Virgin IslandsVGB4.25420.00.00.00.00.00.021.254.25CONCACAF2018-06-07
57786204MontserratMSR4.2517-40.00.00.00.00.00.021.254.25CONCACAF2018-06-07
57787206Turks and Caicos IslandsTCA0.0013-40.00.00.00.00.00.00.000.00CONCACAF2018-06-07
57788206AnguillaAIA0.00010.00.00.00.00.00.00.000.00CONCACAF2018-06-07
57789206BahamasBAH0.00010.00.00.00.00.00.00.000.00CONCACAF2018-06-07
57790206EritreaERI0.00010.00.00.00.00.00.00.000.00CAF2018-06-07
57791206SomaliaSOM0.00010.00.00.00.00.00.00.000.00CAF2018-06-07
57792206TongaTGA0.00010.00.00.00.00.00.00.000.00OFC2018-06-07

Duplicate rows

Most frequent

rankcountry_fullcountry_abrvtotal_pointsprevious_pointsrank_changecur_year_avgcur_year_avg_weightedlast_year_avglast_year_avg_weightedtwo_year_ago_avgtwo_year_ago_weightedthree_year_ago_avgthree_year_ago_weightedconfederationrank_datecount
0100SudanSDN350.663323186.58186.58187.7793.88129.7638.93156.3631.27CAF2012-10-032
1100SudanSDN361.333491243.75243.75120.9260.46163.1248.9440.918.18CAF2013-01-172
2101SudanSDN338.2529212179.70179.70209.32104.667.082.12258.8351.77CAF2012-06-062
3101SudanSDN348.903331206.25206.25126.5563.27219.7265.9167.3613.47CAF2012-12-192
4102SudanSDN333.08351-2178.47178.47155.5277.76207.1662.1573.4914.70CAF2012-11-072
5103SudanSDN331.793291169.05169.05187.7793.88108.1332.44182.1136.42CAF2012-09-052
6104SudanSDN329.363291171.57171.57229.19114.608.502.55203.2240.64CAF2012-08-082
7104SudanSDN343.15361-4207.86207.86156.3478.17163.1248.9440.918.18CAF2013-02-142
8105SudanSDN329.36338-4171.57171.57229.19114.608.502.55203.2240.64CAF2012-07-042
9107SudanSDN297.6222126196.28196.2860.3230.16133.6040.08155.5231.10CAF2014-10-232